至顶网›软件频道 ›Spring调用Oracle的Function函数

Spring调用Oracle的Function函数

扫一扫
分享文章到微信
扫一扫
关注官方公众号
至顶头条

直接调用Oracle内部函数Function的文章

作者：builder.com.cn 来源：来源网站 2007年11月25日

最近搜索了很多网上讲Spring 操作Oracle内部对象的例子，基本上是介绍调用存储过程的~直接调用Oracle内部函数Function的文章真的不多~这里，法老参考了Spring论坛上外国友人的例子，写一个DEMO供大家参考~

测试Oracle函数:
Here is a basic function that returns sysdate in a REF CURSOR:

FUNCTION MY_DEMO_FNC

RETURN MY_REFCURSOR_PKG.RefCursor

return_date MY_REFCURSOR_PKG.RefCursor;

BEGIN

OPEN return_date FOR 'select sysdate from dual';

return return_date;

END MY_DEMO_FNC;

测试程序:
Here is the class that accesses it:

import java.sql.ResultSet;

import java.sql.SQLException;

import java.util.HashMap;

import java.util.Map;

import javax.sql.DataSource;

import oracle.jdbc.OracleTypes;

import org.springframework.jdbc.core.RowCallbackHandler;

import org.springframework.jdbc.core.SqlOutParameter;

import org.springframework.jdbc.datasource.DriverManagerDataSource;

import org.springframework.jdbc.object.StoredProcedure;

public class RefCursorTestDao

{

public static void main(String[] args) throws Exception

{

new RefCursorTestDao().execute();

}

public void execute() throws Exception

{

DataSource ds = new DriverManagerDataSource(

"oracle.jdbc.driver.OracleDriver",

"jdbc:oracle:thin:@localhost:1521:SID1",

"user", "password");

DemoStoredProcedure proc = new DemoStoredProcedure(ds);

Map params = new HashMap();

proc.execute(params);

}

private class DemoStoredProcedure extends StoredProcedure

{

public static final String SQL = "MY_TEST_PKG.MY_DEMO_FNC";

public DemoStoredProcedure(DataSource ds)

{

setDataSource(ds);

setSql(SQL);

setFunction(true);

declareParameter(

new SqlOutParameter(

"whatever", OracleTypes.CURSOR, new DemoRowMapper()));

compile();

}

private class DemoRowMapper implements RowCallbackHandler

{

public void processRow(ResultSet rs) throws SQLException

{

System.out.println(rs.getTimestamp(1));

}

The process is the same for a real procedure with the REF CURSOR as an OUT parameter, but #setFunction should be false instead of true.
参考地址:http://forum.springframework.org/archive/index.php/t-10054.html

Trackback: http://tb.blog.csdn.net/TrackBack.aspx?PostId=1901215

VIP专区

VIP用户

普通用户

闂傚倷绶￠崣搴ㄥ窗閺囩偐鏋庨柕蹇嬪灪婵ジ鏌曡箛瀣偓鏍綖閿燂拷

濠电姷顣介埀顒€鍟块埀顒€缍婇幃妯诲緞閹邦剛鐣洪梺闈浥堥弲婊勬叏濠婂牊鍋ㄦい鏍ㄧ〒閹藉啴鏌熼悜鈺傛珚鐎规洘宀稿畷鍫曞煛閸屾粍娈搁梻浣筋嚃閸ㄤ即宕㈤弽顐ュС闁挎稑瀚崰鍡樸亜閵堝懎濮┑鈽嗗亝濠㈡ê螞濡ゅ懏鍋傛繛鍡樻尭鐎氬鏌嶈閸撶喎顕ｉ渚婄矗濞撴埃鍋撻柣娑欐崌閺屾稑鈹戦崨顕呮▊缂備焦顨呴惌鍌炵嵁鎼淬劌鐒垫い鎺戝鐎氬銇勯弽銊ф噥缂佽妫濋弻鐔碱敇瑜嶉悘鑼磼鏉堛劎绠為柡灞芥喘閺佹劙宕熼鐘虫緰闂佽崵濮抽梽宥夊垂閽樺）锝夊礋椤栨稑娈滈梺纭呮硾椤洟鍩€椤掆偓閿曪妇妲愰弮鍫濈闁绘劕寮Δ鍛厸闁割偒鍋勯悘锕傛煕鐎ｎ偆澧紒鍌涘笧閹瑰嫰鎼圭憴鍕靛晥闂備礁鎼€氱兘宕归柆宥呯；鐎广儱顦伴崕宥夋煕閺囥劌澧ù鐘趁湁闁挎繂妫楅埢鏇㈡煃瑜滈崜姘跺蓟閵娧勵偨闁绘劕顕埢鏇㈡倵閿濆倹娅囨い蹇涗憾閺屾洟宕遍鐔奉伓

重磅专题

往期文章

Spring调用Oracle的Function函数

业界热点: